package com.iflytek.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.iflytek.bean.StockInOrder;
import com.iflytek.bean.StockInOrderExample;
import com.iflytek.vo.StockInOrderVO;

public interface StockInOrderMapper {
    long countByExample(StockInOrderExample example);

    int deleteByExample(StockInOrderExample example);

    int deleteByPrimaryKey(Integer orderId);

    int insert(StockInOrder record);

    int insertSelective(StockInOrder record);

    List<StockInOrder> selectByExample(StockInOrderExample example);

    StockInOrder selectByPrimaryKey(Integer orderId);

    int updateByExampleSelective(@Param("record") StockInOrder record, @Param("example") StockInOrderExample example);

    int updateByExample(@Param("record") StockInOrder record, @Param("example") StockInOrderExample example);

    int updateByPrimaryKeySelective(StockInOrder record);

    int updateByPrimaryKey(StockInOrder record);
    @Select("select * from stock_in_order s join goods g on s.goods_id=g.goods_id join  warehouse w on s.sio_warehouse_id=w.warehouse_id")
	List<StockInOrderVO> showAll();
    @Insert("INSERT INTO is_approval(order_id) VALUES(#{orderId})")
	void insertIsApprove(Integer orderId);
}